using System.Linq;
using System.Text;
using System.Diagnostics;
using System.Runtime.Serialization;
using System.Collections;
using System.Data;
using System.ComponentModel;
using System.Data.OracleClient;
using WPFExcelReport.Helpers;
using WPFExcelReport.Controls;
namespace WPFExcelReport
{
    public partial class VEKREPOS
    {
        public DataRow Convert2EKREPOS(DataRow dwInput, string ITXDBVERSION, bool IsConvert = false)
        {
            DataSet SResult = new DataSet();
            SResult = QueryEKREPOS(dwInput, 0);
            DataRow dwReturn = null;
            if (SResult.Tables[0].Rows.Count > 0)
            {
                dwReturn = SResult.Tables[0].Rows[0];
            }
            else
            {
                dwReturn = SResult.Tables[0].NewRow();
            }
            switch (ITXDBVERSION)
            {
                case "YGR":
                    #region=========
         dwReturn["EKRPMANDANT"] = " ".PadRight(2 ); 
         dwReturn["EKRPLIEFNR"] = " ".PadRight(8 ); 
         dwReturn["EKRPRENR"] = " ".PadRight(10 ); 
         dwReturn["EKRPREPOS"] = " ".PadRight(3 ); 
         dwReturn["EKRPAENZL"] = " ".PadRight(0 ); 
         dwReturn["EKRPAENB"] = " ".PadRight(8 ); 
         dwReturn["EKRPAEND"] = " ".PadRight(0 ); 
         dwReturn["EKRPNEUB"] = " ".PadRight(8 ); 
         dwReturn["EKRPNEUD"] = " ".PadRight(0 ); 
         dwReturn["EKRPRGDAT"] = " ".PadRight(0 ); 
         dwReturn["EKRPSTA"] = " ".PadRight(1 ); 
         dwReturn["EKRPLIEFSCH"] = " ".PadRight(10 ); 
         dwReturn["EKRPABSEND"] = " ".PadRight(8 ); 
         dwReturn["EKRPAUFKRS"] = " ".PadRight(2 ); 
         dwReturn["EKRPAUFLFD"] = " ".PadRight(6 ); 
         dwReturn["EKRPPOS1"] = " ".PadRight(3 ); 
         dwReturn["EKRPARTGR"] = " ".PadRight(1 ); 
         dwReturn["EKRPEINHAN"] = " ".PadRight(0 ); 
         dwReturn["EKRPEINBRUT"] = " ".PadRight(0 ); 
         dwReturn["EKRPEINNET"] = " ".PadRight(0 ); 
         dwReturn["EKRPEINKART"] = " ".PadRight(0 ); 
         dwReturn["EKRPEINSPUL"] = " ".PadRight(0 ); 
         dwReturn["EKRPVERPACK"] = " ".PadRight(0 ); 
         dwReturn["EKRPHUELSEN"] = " ".PadRight(0 ); 
         dwReturn["EKRPPARTIE"] = " ".PadRight(8 ); 
         dwReturn["EKRPARTIKEL"] = " ".PadRight(40 ); 
         dwReturn["EKRPVARIANTE"] = " ".PadRight(3 ); 
         dwReturn["EKRPARTFARBE"] = " ".PadRight(10 ); 
         dwReturn["EKRPARTDESS"] = " ".PadRight(10 ); 
         dwReturn["EKRPARTCOL"] = " ".PadRight(10 ); 
         dwReturn["EKRPARTBESCH"] = " ".PadRight(10 ); 
         dwReturn["EKRPSPEZREST"] = " ".PadRight(550 ); 
         dwReturn["EKRPMENGE"] = " ".PadRight(0 ); 
         dwReturn["EKRPMEEH"] = " ".PadRight(3 ); 
         dwReturn["EKRPMEEHGRP"] = " ".PadRight(1 ); 
         dwReturn["EKRPMEEHFKT"] = " ".PadRight(12 ); 
         dwReturn["EKRPWARENWERT"] = " ".PadRight(0 ); 
         dwReturn["EKRPVERPAB"] = " ".PadRight(0 ); 
         dwReturn["EKRPFRAAB"] = " ".PadRight(0 ); 
         dwReturn["EKRPVERSAB"] = " ".PadRight(0 ); 
         dwReturn["EKRPZOLLAB"] = " ".PadRight(0 ); 
         dwReturn["EKRPFRAPAU"] = " ".PadRight(0 ); 
         dwReturn["EKRPVERSPAU"] = " ".PadRight(0 ); 
         dwReturn["EKRPZOLLPAU"] = " ".PadRight(0 ); 
         dwReturn["EKRPPARTWERT"] = " ".PadRight(0 ); 
         dwReturn["EKRPMWSTP"] = " ".PadRight(0 ); 
         dwReturn["EKRPMWST"] = " ".PadRight(0 ); 
         dwReturn["EKRPFRMWSTPFL"] = " ".PadRight(0 ); 
         dwReturn["EKRPFRMWSTF"] = " ".PadRight(0 ); 
         dwReturn["EKRPPRME"] = " ".PadRight(10 ); 
         dwReturn["EKRPPREH"] = " ".PadRight(3 ); 
         dwReturn["EKRPPREHGRP"] = " ".PadRight(1 ); 
         dwReturn["EKRPPREHFKT"] = " ".PadRight(12 ); 
         dwReturn["EKRPZUAB1"] = " ".PadRight(3 ); 
         dwReturn["EKRPZUABPR1"] = " ".PadRight(0 ); 
         dwReturn["EKRPZUABWE1"] = " ".PadRight(0 ); 
         dwReturn["EKRPZUABME1"] = " ".PadRight(3 ); 
         dwReturn["EKRPZUABEB1"] = " ".PadRight(1 ); 
         dwReturn["EKRPZUABLV1"] = " ".PadRight(1 ); 
         dwReturn["EKRPZUABBETR1"] = " ".PadRight(0 ); 
         dwReturn["EKRPZUAB2"] = " ".PadRight(3 ); 
         dwReturn["EKRPZUABPR2"] = " ".PadRight(0 ); 
         dwReturn["EKRPZUABWE2"] = " ".PadRight(0 ); 
         dwReturn["EKRPZUABME2"] = " ".PadRight(3 ); 
         dwReturn["EKRPZUABEB2"] = " ".PadRight(1 ); 
         dwReturn["EKRPZUABLV2"] = " ".PadRight(1 ); 
         dwReturn["EKRPZUABBETR2"] = " ".PadRight(0 ); 
         dwReturn["EKRPZUAB3"] = " ".PadRight(3 ); 
         dwReturn["EKRPZUABPR3"] = " ".PadRight(0 ); 
         dwReturn["EKRPZUABWE3"] = " ".PadRight(0 ); 
         dwReturn["EKRPZUABME3"] = " ".PadRight(3 ); 
         dwReturn["EKRPZUABEB3"] = " ".PadRight(1 ); 
         dwReturn["EKRPZUABLV3"] = " ".PadRight(1 ); 
         dwReturn["EKRPZUABBETR3"] = " ".PadRight(0 ); 
         dwReturn["EKRPZUAB4"] = " ".PadRight(3 ); 
         dwReturn["EKRPZUABPR4"] = " ".PadRight(0 ); 
         dwReturn["EKRPZUABWE4"] = " ".PadRight(0 ); 
         dwReturn["EKRPZUABME4"] = " ".PadRight(3 ); 
         dwReturn["EKRPZUABEB4"] = " ".PadRight(1 ); 
         dwReturn["EKRPZUABLV4"] = " ".PadRight(1 ); 
         dwReturn["EKRPZUABBETR4"] = " ".PadRight(0 ); 
         dwReturn["EKRPZUAB5"] = " ".PadRight(3 ); 
         dwReturn["EKRPZUABPR5"] = " ".PadRight(0 ); 
         dwReturn["EKRPZUABWE5"] = " ".PadRight(0 ); 
         dwReturn["EKRPZUABME5"] = " ".PadRight(3 ); 
         dwReturn["EKRPZUABEB5"] = " ".PadRight(1 ); 
         dwReturn["EKRPZUABLV5"] = " ".PadRight(1 ); 
         dwReturn["EKRPZUABBETR5"] = " ".PadRight(0 ); 
         dwReturn["EKRPRABATTKZ"] = " ".PadRight(1 ); 
         dwReturn["EKRPRABATT"] = " ".PadRight(0 ); 
         dwReturn["EKRPRABATTWE"] = " ".PadRight(0 ); 
         dwReturn["EKRPRABART1"] = " ".PadRight(3 ); 
         dwReturn["EKRPRABPROZ1"] = " ".PadRight(0 ); 
         dwReturn["EKRPRABWERT1"] = " ".PadRight(0 ); 
         dwReturn["EKRPRABEB1"] = " ".PadRight(1 ); 
         dwReturn["EKRPRABLV1"] = " ".PadRight(1 ); 
         dwReturn["EKRPRABART2"] = " ".PadRight(3 ); 
         dwReturn["EKRPRABPROZ2"] = " ".PadRight(0 ); 
         dwReturn["EKRPRABWERT2"] = " ".PadRight(0 ); 
         dwReturn["EKRPRABEB2"] = " ".PadRight(1 ); 
         dwReturn["EKRPRABLV2"] = " ".PadRight(1 ); 
         dwReturn["EKRPRABART3"] = " ".PadRight(3 ); 
         dwReturn["EKRPRABPROZ3"] = " ".PadRight(0 ); 
         dwReturn["EKRPRABWERT3"] = " ".PadRight(0 ); 
         dwReturn["EKRPRABEB3"] = " ".PadRight(1 ); 
         dwReturn["EKRPRABLV3"] = " ".PadRight(1 ); 
         dwReturn["EKRPRABART4"] = " ".PadRight(3 ); 
         dwReturn["EKRPRABPROZ4"] = " ".PadRight(0 ); 
         dwReturn["EKRPRABWERT4"] = " ".PadRight(0 ); 
         dwReturn["EKRPRABEB4"] = " ".PadRight(1 ); 
         dwReturn["EKRPRABLV4"] = " ".PadRight(1 ); 
         dwReturn["EKRPRABART5"] = " ".PadRight(3 ); 
         dwReturn["EKRPRABPROZ5"] = " ".PadRight(0 ); 
         dwReturn["EKRPRABWERT5"] = " ".PadRight(0 ); 
         dwReturn["EKRPRABEB5"] = " ".PadRight(1 ); 
         dwReturn["EKRPRABLV5"] = " ".PadRight(1 ); 
         dwReturn["EKRPFIXBONP"] = " ".PadRight(0 ); 
         dwReturn["EKRPFIXBONA"] = " ".PadRight(0 ); 
         dwReturn["EKRPKALBONP"] = " ".PadRight(0 ); 
         dwReturn["EKRPKALBONA"] = " ".PadRight(0 ); 
         dwReturn["EKRPKONAB"] = " ".PadRight(1 ); 
         dwReturn["EKRPKODIFFME"] = " ".PadRight(0 ); 
         dwReturn["EKRPKODIFFWE"] = " ".PadRight(0 ); 
         dwReturn["EKRPKTOKL4"] = " ".PadRight(6 ); 
         dwReturn["EKRPKSTKRS"] = " ".PadRight(2 ); 
         dwReturn["EKRPKST"] = " ".PadRight(4 ); 
         dwReturn["EKRPBUDGET"] = " ".PadRight(8 ); 
         dwReturn["EKRPINVAUF"] = " ".PadRight(8 ); 
         dwReturn["EKRPWAEHRSL"] = " ".PadRight(3 ); 
         dwReturn["EKRPKURS"] = " ".PadRight(0 ); 
         dwReturn["EKRPBETRAG"] = " ".PadRight(0 ); 
         dwReturn["EKRPHWAEHRSL"] = " ".PadRight(3 ); 
         dwReturn["EKRPHEUROKURS"] = " ".PadRight(0 ); 
         dwReturn["EKRPHEUROKUVK"] = " ".PadRight(1 ); 
         dwReturn["EKRPFEUROKURS"] = " ".PadRight(0 ); 
         dwReturn["EKRPFEUROKUVK"] = " ".PadRight(1 ); 
         dwReturn["EKRPTERMNR"] = " ".PadRight(0 ); 
         dwReturn["EKRPFAELLIG"] = " ".PadRight(0 ); 
         dwReturn["EKRPSICHER"] = " ".PadRight(1 ); 
         dwReturn["EKRPSICHP"] = " ".PadRight(0 ); 
         dwReturn["EKRPAKKRED"] = " ".PadRight(15 ); 
         dwReturn["EKRPPRFBENID"] = " ".PadRight(8 ); 
         dwReturn["EKRPMAILDAT"] = " ".PadRight(0 ); 
         dwReturn["EKRPUEBKZ"] = " ".PadRight(1 ); 
         dwReturn["EKRPURLAND"] = " ".PadRight(3 ); 
         dwReturn["EKRPWR"] = " ".PadRight(8 ); 
         dwReturn["EKRPPRFBEG"] = " ".PadRight(1 ); 
         dwReturn["EKRPPRFSCHL"] = " ".PadRight(9 ); 
         dwReturn["EKRPZOLLTNR"] = " ".PadRight(20 ); 
         dwReturn["EKRPLEKLNR"] = " ".PadRight(0 ); 
         dwReturn["EKRPVBCOSTS"] = " ".PadRight(0 ); 
         dwReturn["EKRPFRAGR"] = " ".PadRight(0 ); 
         dwReturn["EKRPVERSGR"] = " ".PadRight(0 ); 
         dwReturn["EKRPSTZOLLP"] = " ".PadRight(0 ); 
         dwReturn["EKRPSTZOLLAB"] = " ".PadRight(0 ); 
         dwReturn["EKRPIMCOSTS"] = " ".PadRight(0 ); 
         dwReturn["EKRPCOBORDER"] = " ".PadRight(0 ); 
         dwReturn["EKRPAVVME"] = " ".PadRight(0 ); 
         dwReturn["EKRPZOLLANM"] = " ".PadRight(1 ); 
         dwReturn["EKRPEUR1"] = " ".PadRight(1 ); 
         dwReturn["EKRPZUSTAND"] = " ".PadRight(4 ); 
         dwReturn["EKRPINTRA"] = " ".PadRight(1 ); 
         dwReturn["EKRPGRUND"] = " ".PadRight(3 ); 
         dwReturn["EKRPRRENR"] = " ".PadRight(10 ); 
         dwReturn["EKRPRREPOS"] = " ".PadRight(3 ); 
         dwReturn["EKRPWERTDAT"] = " ".PadRight(0 ); 
         dwReturn["EKRPLANDCOST"] = " ".PadRight(0 ); 
         dwReturn["EKRPFILLER5"] = " ".PadRight(79 ); 
                    #endregion
                    break;
                case "JLT":

                    break;
                default:

                    break;
            }
            if (IsConvert)
            {
                foreach (DataColumn cm in dwInput.Table.Columns)
                {
                    if (dwInput[cm.ColumnName].ToString() == "")
                        continue;
                    if (dwReturn.Table.Columns.Contains(cm.ColumnName))
                    {
                        dwReturn[cm.ColumnName] = dwInput[cm.ColumnName];
                    }
                }
            }
            return dwReturn;
        }
        public void MapEKREPOS(ref DataRow dwLocal, DataRow dwData)
        {
            BlindMap(ref dwLocal, dwData);
        }
        public void SaveEKREPOS(DataRow dwData, string ITXDBVERSION = "50.24")
        {
            DataSet setResult = new DataSet();
            DataTable tbLocal = null;
            DataRow dwLocal = null;
            bool flgExist = false;
            setResult = QueryEKREPOS(dwData);
            if (setResult.Tables.Count > 0)
            {
                tbLocal = setResult.Tables[0];
                if (tbLocal.Rows.Count > 0)
                {
                    flgExist = true;
                    dwLocal = tbLocal.Rows[0];
                }
                else
                {
                    dwLocal = tbLocal.NewRow();
                }
            }
            MapEKREPOS(ref dwLocal, dwData);

            if (!flgExist)
            {

                InsertEKREPOS(dwLocal, ITXDBVERSION);
            }
            UpdateEKREPOS(dwLocal);
        }
        public void InsertEKREPOS(DataRow dwData, string ITXDBVERSION = "50.24")
        {
            OracleCommand or1;
            or1 = OracleDB.CreateCommand();
            switch (ITXDBVERSION)
            {
                case "YGR":
                    or1.CommandText = "INSERT INTO EKREPOS(VAKBMANDANT, VAKBKOLL, VAKBART, VAKBKUNDNR, VAKBFARBE, VAKBKDARTNR, VAKBKDARTBEZ, VAKBKDFARBNR, VAKBANDRUCK, VAKBMEGEW, VAKBMENGEH, VAKBGEWVON, VAKBGEWBIS, VAKBGEWCA, VAKBGEWFKT, VAKBGEWGRP, VAKBMEGFKT, VAKBMEGGRP, VAKBAENDZL, VAKBAENDBEN, VAKBAENDDAT, VAKBNEUBEN, VAKBNEUDAT, VAKBFILLER)"
                        + " VALUES (:VAKBMANDANT, :VAKBKOLL, :VAKBART, :VAKBKUNDNR, :VAKBFARBE, '                         ', '                         ', '                             ', ' ', '   ', '   ', 0, 0, ' ', '000000000000', ' ', '000000000000', ' ', 0, '        ', '000000', '        ', '      ', '                                          ')";
                    or1.Parameters.Add("VAKBMANDANT", OracleType.NVarChar).Value = dwData["VAKBMANDANT"].ToString();
                    or1.Parameters.Add("VAKBKOLL", OracleType.NVarChar).Value = dwData["VAKBKOLL"].ToString();
                    or1.Parameters.Add("VAKBART", OracleType.NVarChar).Value = dwData["VAKBART"].ToString();
                    or1.Parameters.Add("VAKBFARBE", OracleType.NVarChar).Value = dwData["VAKBFARBE"].ToString();
                    or1.Parameters.Add("VAKBKUNDNR", OracleType.NVarChar).Value = dwData["VAKBKUNDNR"].ToString();
                    break;
                //VAFMANDANT VAFKOLL VAFART VAFFARBE VAFBEZ VAFFFARBE

            }
            
            Connect2Proxy(or1);
        }
        public DataSet QueryEKREPOS(DataRow dwData, int option = 1)
        {
            DataSet Return;
            DataSet Result = new DataSet();
            OracleCommand or1 = OracleDB.CreateCommand();
            switch (option)
            {
                case 0:
                    or1.CommandText = "SELECT * FROM EKREPOS WHERE  ROWNUM<2 ";
                    break;
              
                case 99:
                    or1.CommandText = "SELECT * FROM EKREPOS  WHERE ROWNUM<50";
                    break;
                default:
                    break;
            }
            Result = Connect2Proxy(or1);
            if (Result.Tables.Count > 0)
                Result.Tables[0].TableName = "EKREPOS";
            Return = Result;
            return Return;
        }
        public void DeleteEKREPOS(DataRow dwData, int option = 1)
        {

            OracleCommand or1 = OracleDB.CreateCommand();
            switch (option)
            {
                case 1:
                    or1.CommandText = "DELETE FROM EKREPOS   WHERE  VAKBMANDANT=:VAKBMANDANT AND VAKBKOLL=:VAKBKOLL AND VAKBART =:VAKBART AND VAKBFARBE=:VAKBFARBE AND VAKBKUNDNR=:VAKBKUNDNR";
                     or1.Parameters.Add("VAKBMANDANT", OracleType.NVarChar).Value = dwData["VAKBMANDANT"].ToString();
                    or1.Parameters.Add("VAKBKOLL", OracleType.NVarChar).Value = dwData["VAKBKOLL"].ToString();
                    or1.Parameters.Add("VAKBART", OracleType.NVarChar).Value = dwData["VAKBART"].ToString();
                    or1.Parameters.Add("VAKBFARBE", OracleType.NVarChar).Value = dwData["VAKBFARBE"].ToString();
                    or1.Parameters.Add("VAKBKUNDNR", OracleType.NVarChar).Value = dwData["VAKBKUNDNR"].ToString();
                    break;
                default:
                    break;
            }
            Connect2Proxy(or1);
        } 
      
        public void UpdateEKREPOS(DataRow dwData, string ITXDBVERSION = "50.24", int option = 1)
        {
            OracleCommand or1;
            DataSet Result = new DataSet();
            or1 = OracleDB.CreateCommand();
            switch (option)
            {
                case 1:
                    #region====Command==== 
                    or1.CommandText = "UPDATE EKREPOS SET "
                    +"EKRPMANDANT= :EKRPMANDANT,"
                    +"EKRPLIEFNR= :EKRPLIEFNR,"
                    +"EKRPRENR= :EKRPRENR,"
                    +"EKRPREPOS= :EKRPREPOS,"
                    +"EKRPAENZL= :EKRPAENZL,"
                    +"EKRPAENB= :EKRPAENB,"
                    +"EKRPAEND= :EKRPAEND,"
                    +"EKRPNEUB= :EKRPNEUB,"
                    +"EKRPNEUD= :EKRPNEUD,"
                    +"EKRPRGDAT= :EKRPRGDAT,"
                    +"EKRPSTA= :EKRPSTA,"
                    +"EKRPLIEFSCH= :EKRPLIEFSCH,"
                    +"EKRPABSEND= :EKRPABSEND,"
                    +"EKRPAUFKRS= :EKRPAUFKRS,"
                    +"EKRPAUFLFD= :EKRPAUFLFD,"
                    +"EKRPPOS1= :EKRPPOS1,"
                    +"EKRPARTGR= :EKRPARTGR,"
                    +"EKRPEINHAN= :EKRPEINHAN,"
                    +"EKRPEINBRUT= :EKRPEINBRUT,"
                    +"EKRPEINNET= :EKRPEINNET,"
                    +"EKRPEINKART= :EKRPEINKART,"
                    +"EKRPEINSPUL= :EKRPEINSPUL,"
                    +"EKRPVERPACK= :EKRPVERPACK,"
                    +"EKRPHUELSEN= :EKRPHUELSEN,"
                    +"EKRPPARTIE= :EKRPPARTIE,"
                    +"EKRPARTIKEL= :EKRPARTIKEL,"
                    +"EKRPVARIANTE= :EKRPVARIANTE,"
                    +"EKRPARTFARBE= :EKRPARTFARBE,"
                    +"EKRPARTDESS= :EKRPARTDESS,"
                    +"EKRPARTCOL= :EKRPARTCOL,"
                    +"EKRPARTBESCH= :EKRPARTBESCH,"
                    +"EKRPSPEZREST= :EKRPSPEZREST,"
                    +"EKRPMENGE= :EKRPMENGE,"
                    +"EKRPMEEH= :EKRPMEEH,"
                    +"EKRPMEEHGRP= :EKRPMEEHGRP,"
                    +"EKRPMEEHFKT= :EKRPMEEHFKT,"
                    +"EKRPWARENWERT= :EKRPWARENWERT,"
                    +"EKRPVERPAB= :EKRPVERPAB,"
                    +"EKRPFRAAB= :EKRPFRAAB,"
                    +"EKRPVERSAB= :EKRPVERSAB,"
                    +"EKRPZOLLAB= :EKRPZOLLAB,"
                    +"EKRPFRAPAU= :EKRPFRAPAU,"
                    +"EKRPVERSPAU= :EKRPVERSPAU,"
                    +"EKRPZOLLPAU= :EKRPZOLLPAU,"
                    +"EKRPPARTWERT= :EKRPPARTWERT,"
                    +"EKRPMWSTP= :EKRPMWSTP,"
                    +"EKRPMWST= :EKRPMWST,"
                    +"EKRPFRMWSTPFL= :EKRPFRMWSTPFL,"
                    +"EKRPFRMWSTF= :EKRPFRMWSTF,"
                    +"EKRPPRME= :EKRPPRME,"
                    +"EKRPPREH= :EKRPPREH,"
                    +"EKRPPREHGRP= :EKRPPREHGRP,"
                    +"EKRPPREHFKT= :EKRPPREHFKT,"
                    +"EKRPZUAB1= :EKRPZUAB1,"
                    +"EKRPZUABPR1= :EKRPZUABPR1,"
                    +"EKRPZUABWE1= :EKRPZUABWE1,"
                    +"EKRPZUABME1= :EKRPZUABME1,"
                    +"EKRPZUABEB1= :EKRPZUABEB1,"
                    +"EKRPZUABLV1= :EKRPZUABLV1,"
                    +"EKRPZUABBETR1= :EKRPZUABBETR1,"
                    +"EKRPZUAB2= :EKRPZUAB2,"
                    +"EKRPZUABPR2= :EKRPZUABPR2,"
                    +"EKRPZUABWE2= :EKRPZUABWE2,"
                    +"EKRPZUABME2= :EKRPZUABME2,"
                    +"EKRPZUABEB2= :EKRPZUABEB2,"
                    +"EKRPZUABLV2= :EKRPZUABLV2,"
                    +"EKRPZUABBETR2= :EKRPZUABBETR2,"
                    +"EKRPZUAB3= :EKRPZUAB3,"
                    +"EKRPZUABPR3= :EKRPZUABPR3,"
                    +"EKRPZUABWE3= :EKRPZUABWE3,"
                    +"EKRPZUABME3= :EKRPZUABME3,"
                    +"EKRPZUABEB3= :EKRPZUABEB3,"
                    +"EKRPZUABLV3= :EKRPZUABLV3,"
                    +"EKRPZUABBETR3= :EKRPZUABBETR3,"
                    +"EKRPZUAB4= :EKRPZUAB4,"
                    +"EKRPZUABPR4= :EKRPZUABPR4,"
                    +"EKRPZUABWE4= :EKRPZUABWE4,"
                    +"EKRPZUABME4= :EKRPZUABME4,"
                    +"EKRPZUABEB4= :EKRPZUABEB4,"
                    +"EKRPZUABLV4= :EKRPZUABLV4,"
                    +"EKRPZUABBETR4= :EKRPZUABBETR4,"
                    +"EKRPZUAB5= :EKRPZUAB5,"
                    +"EKRPZUABPR5= :EKRPZUABPR5,"
                    +"EKRPZUABWE5= :EKRPZUABWE5,"
                    +"EKRPZUABME5= :EKRPZUABME5,"
                    +"EKRPZUABEB5= :EKRPZUABEB5,"
                    +"EKRPZUABLV5= :EKRPZUABLV5,"
                    +"EKRPZUABBETR5= :EKRPZUABBETR5,"
                    +"EKRPRABATTKZ= :EKRPRABATTKZ,"
                    +"EKRPRABATT= :EKRPRABATT,"
                    +"EKRPRABATTWE= :EKRPRABATTWE,"
                    +"EKRPRABART1= :EKRPRABART1,"
                    +"EKRPRABPROZ1= :EKRPRABPROZ1,"
                    +"EKRPRABWERT1= :EKRPRABWERT1,"
                    +"EKRPRABEB1= :EKRPRABEB1,"
                    +"EKRPRABLV1= :EKRPRABLV1,"
                    +"EKRPRABART2= :EKRPRABART2,"
                    +"EKRPRABPROZ2= :EKRPRABPROZ2,"
                    +"EKRPRABWERT2= :EKRPRABWERT2,"
                    +"EKRPRABEB2= :EKRPRABEB2,"
                    +"EKRPRABLV2= :EKRPRABLV2,"
                    +"EKRPRABART3= :EKRPRABART3,"
                    +"EKRPRABPROZ3= :EKRPRABPROZ3,"
                    +"EKRPRABWERT3= :EKRPRABWERT3,"
                    +"EKRPRABEB3= :EKRPRABEB3,"
                    +"EKRPRABLV3= :EKRPRABLV3,"
                    +"EKRPRABART4= :EKRPRABART4,"
                    +"EKRPRABPROZ4= :EKRPRABPROZ4,"
                    +"EKRPRABWERT4= :EKRPRABWERT4,"
                    +"EKRPRABEB4= :EKRPRABEB4,"
                    +"EKRPRABLV4= :EKRPRABLV4,"
                    +"EKRPRABART5= :EKRPRABART5,"
                    +"EKRPRABPROZ5= :EKRPRABPROZ5,"
                    +"EKRPRABWERT5= :EKRPRABWERT5,"
                    +"EKRPRABEB5= :EKRPRABEB5,"
                    +"EKRPRABLV5= :EKRPRABLV5,"
                    +"EKRPFIXBONP= :EKRPFIXBONP,"
                    +"EKRPFIXBONA= :EKRPFIXBONA,"
                    +"EKRPKALBONP= :EKRPKALBONP,"
                    +"EKRPKALBONA= :EKRPKALBONA,"
                    +"EKRPKONAB= :EKRPKONAB,"
                    +"EKRPKODIFFME= :EKRPKODIFFME,"
                    +"EKRPKODIFFWE= :EKRPKODIFFWE,"
                    +"EKRPKTOKL4= :EKRPKTOKL4,"
                    +"EKRPKSTKRS= :EKRPKSTKRS,"
                    +"EKRPKST= :EKRPKST,"
                    +"EKRPBUDGET= :EKRPBUDGET,"
                    +"EKRPINVAUF= :EKRPINVAUF,"
                    +"EKRPWAEHRSL= :EKRPWAEHRSL,"
                    +"EKRPKURS= :EKRPKURS,"
                    +"EKRPBETRAG= :EKRPBETRAG,"
                    +"EKRPHWAEHRSL= :EKRPHWAEHRSL,"
                    +"EKRPHEUROKURS= :EKRPHEUROKURS,"
                    +"EKRPHEUROKUVK= :EKRPHEUROKUVK,"
                    +"EKRPFEUROKURS= :EKRPFEUROKURS,"
                    +"EKRPFEUROKUVK= :EKRPFEUROKUVK,"
                    +"EKRPTERMNR= :EKRPTERMNR,"
                    +"EKRPFAELLIG= :EKRPFAELLIG,"
                    +"EKRPSICHER= :EKRPSICHER,"
                    +"EKRPSICHP= :EKRPSICHP,"
                    +"EKRPAKKRED= :EKRPAKKRED,"
                    +"EKRPPRFBENID= :EKRPPRFBENID,"
                    +"EKRPMAILDAT= :EKRPMAILDAT,"
                    +"EKRPUEBKZ= :EKRPUEBKZ,"
                    +"EKRPURLAND= :EKRPURLAND,"
                    +"EKRPWR= :EKRPWR,"
                    +"EKRPPRFBEG= :EKRPPRFBEG,"
                    +"EKRPPRFSCHL= :EKRPPRFSCHL,"
                    +"EKRPZOLLTNR= :EKRPZOLLTNR,"
                    +"EKRPLEKLNR= :EKRPLEKLNR,"
                    +"EKRPVBCOSTS= :EKRPVBCOSTS,"
                    +"EKRPFRAGR= :EKRPFRAGR,"
                    +"EKRPVERSGR= :EKRPVERSGR,"
                    +"EKRPSTZOLLP= :EKRPSTZOLLP,"
                    +"EKRPSTZOLLAB= :EKRPSTZOLLAB,"
                    +"EKRPIMCOSTS= :EKRPIMCOSTS,"
                    +"EKRPCOBORDER= :EKRPCOBORDER,"
                    +"EKRPAVVME= :EKRPAVVME,"
                    +"EKRPZOLLANM= :EKRPZOLLANM,"
                    +"EKRPEUR1= :EKRPEUR1,"
                    +"EKRPZUSTAND= :EKRPZUSTAND,"
                    +"EKRPINTRA= :EKRPINTRA,"
                    +"EKRPGRUND= :EKRPGRUND,"
                    +"EKRPRRENR= :EKRPRRENR,"
                    +"EKRPRREPOS= :EKRPRREPOS,"
                    +"EKRPWERTDAT= :EKRPWERTDAT,"
                    +"EKRPLANDCOST= :EKRPLANDCOST,"
                    +"EKRPFILLER5= :EKRPFILLER5,"
                        + " WHERE  "
                        + "  VAKBMANDANT=:VAKBMANDANT AND VAKBKOLL=:VAKBKOLL AND VAKBART =:VAKBART AND VAKBFARBE=:VAKBFARBE AND VAKBKUNDNR=:VAKBKUNDNR";
                    #endregion

                    #region====Parameters====
          or1.Parameters.Add("EKRPMANDANT", OracleType.NVarChar).Value = dwData["EKRPMANDANT"].ToString(); 
          or1.Parameters.Add("EKRPLIEFNR", OracleType.NVarChar).Value = dwData["EKRPLIEFNR"].ToString(); 
          or1.Parameters.Add("EKRPRENR", OracleType.NVarChar).Value = dwData["EKRPRENR"].ToString(); 
          or1.Parameters.Add("EKRPREPOS", OracleType.NVarChar).Value = dwData["EKRPREPOS"].ToString(); 
          or1.Parameters.Add("EKRPAENZL", OracleType.NVarChar).Value = dwData["EKRPAENZL"].ToString(); 
          or1.Parameters.Add("EKRPAENB", OracleType.NVarChar).Value = dwData["EKRPAENB"].ToString(); 
          or1.Parameters.Add("EKRPAEND", OracleType.NVarChar).Value = dwData["EKRPAEND"].ToString(); 
          or1.Parameters.Add("EKRPNEUB", OracleType.NVarChar).Value = dwData["EKRPNEUB"].ToString(); 
          or1.Parameters.Add("EKRPNEUD", OracleType.NVarChar).Value = dwData["EKRPNEUD"].ToString(); 
          or1.Parameters.Add("EKRPRGDAT", OracleType.NVarChar).Value = dwData["EKRPRGDAT"].ToString(); 
          or1.Parameters.Add("EKRPSTA", OracleType.NVarChar).Value = dwData["EKRPSTA"].ToString(); 
          or1.Parameters.Add("EKRPLIEFSCH", OracleType.NVarChar).Value = dwData["EKRPLIEFSCH"].ToString(); 
          or1.Parameters.Add("EKRPABSEND", OracleType.NVarChar).Value = dwData["EKRPABSEND"].ToString(); 
          or1.Parameters.Add("EKRPAUFKRS", OracleType.NVarChar).Value = dwData["EKRPAUFKRS"].ToString(); 
          or1.Parameters.Add("EKRPAUFLFD", OracleType.NVarChar).Value = dwData["EKRPAUFLFD"].ToString(); 
          or1.Parameters.Add("EKRPPOS1", OracleType.NVarChar).Value = dwData["EKRPPOS1"].ToString(); 
          or1.Parameters.Add("EKRPARTGR", OracleType.NVarChar).Value = dwData["EKRPARTGR"].ToString(); 
          or1.Parameters.Add("EKRPEINHAN", OracleType.NVarChar).Value = dwData["EKRPEINHAN"].ToString(); 
          or1.Parameters.Add("EKRPEINBRUT", OracleType.NVarChar).Value = dwData["EKRPEINBRUT"].ToString(); 
          or1.Parameters.Add("EKRPEINNET", OracleType.NVarChar).Value = dwData["EKRPEINNET"].ToString(); 
          or1.Parameters.Add("EKRPEINKART", OracleType.NVarChar).Value = dwData["EKRPEINKART"].ToString(); 
          or1.Parameters.Add("EKRPEINSPUL", OracleType.NVarChar).Value = dwData["EKRPEINSPUL"].ToString(); 
          or1.Parameters.Add("EKRPVERPACK", OracleType.NVarChar).Value = dwData["EKRPVERPACK"].ToString(); 
          or1.Parameters.Add("EKRPHUELSEN", OracleType.NVarChar).Value = dwData["EKRPHUELSEN"].ToString(); 
          or1.Parameters.Add("EKRPPARTIE", OracleType.NVarChar).Value = dwData["EKRPPARTIE"].ToString(); 
          or1.Parameters.Add("EKRPARTIKEL", OracleType.NVarChar).Value = dwData["EKRPARTIKEL"].ToString(); 
          or1.Parameters.Add("EKRPVARIANTE", OracleType.NVarChar).Value = dwData["EKRPVARIANTE"].ToString(); 
          or1.Parameters.Add("EKRPARTFARBE", OracleType.NVarChar).Value = dwData["EKRPARTFARBE"].ToString(); 
          or1.Parameters.Add("EKRPARTDESS", OracleType.NVarChar).Value = dwData["EKRPARTDESS"].ToString(); 
          or1.Parameters.Add("EKRPARTCOL", OracleType.NVarChar).Value = dwData["EKRPARTCOL"].ToString(); 
          or1.Parameters.Add("EKRPARTBESCH", OracleType.NVarChar).Value = dwData["EKRPARTBESCH"].ToString(); 
          or1.Parameters.Add("EKRPSPEZREST", OracleType.NVarChar).Value = dwData["EKRPSPEZREST"].ToString(); 
          or1.Parameters.Add("EKRPMENGE", OracleType.NVarChar).Value = dwData["EKRPMENGE"].ToString(); 
          or1.Parameters.Add("EKRPMEEH", OracleType.NVarChar).Value = dwData["EKRPMEEH"].ToString(); 
          or1.Parameters.Add("EKRPMEEHGRP", OracleType.NVarChar).Value = dwData["EKRPMEEHGRP"].ToString(); 
          or1.Parameters.Add("EKRPMEEHFKT", OracleType.NVarChar).Value = dwData["EKRPMEEHFKT"].ToString(); 
          or1.Parameters.Add("EKRPWARENWERT", OracleType.NVarChar).Value = dwData["EKRPWARENWERT"].ToString(); 
          or1.Parameters.Add("EKRPVERPAB", OracleType.NVarChar).Value = dwData["EKRPVERPAB"].ToString(); 
          or1.Parameters.Add("EKRPFRAAB", OracleType.NVarChar).Value = dwData["EKRPFRAAB"].ToString(); 
          or1.Parameters.Add("EKRPVERSAB", OracleType.NVarChar).Value = dwData["EKRPVERSAB"].ToString(); 
          or1.Parameters.Add("EKRPZOLLAB", OracleType.NVarChar).Value = dwData["EKRPZOLLAB"].ToString(); 
          or1.Parameters.Add("EKRPFRAPAU", OracleType.NVarChar).Value = dwData["EKRPFRAPAU"].ToString(); 
          or1.Parameters.Add("EKRPVERSPAU", OracleType.NVarChar).Value = dwData["EKRPVERSPAU"].ToString(); 
          or1.Parameters.Add("EKRPZOLLPAU", OracleType.NVarChar).Value = dwData["EKRPZOLLPAU"].ToString(); 
          or1.Parameters.Add("EKRPPARTWERT", OracleType.NVarChar).Value = dwData["EKRPPARTWERT"].ToString(); 
          or1.Parameters.Add("EKRPMWSTP", OracleType.NVarChar).Value = dwData["EKRPMWSTP"].ToString(); 
          or1.Parameters.Add("EKRPMWST", OracleType.NVarChar).Value = dwData["EKRPMWST"].ToString(); 
          or1.Parameters.Add("EKRPFRMWSTPFL", OracleType.NVarChar).Value = dwData["EKRPFRMWSTPFL"].ToString(); 
          or1.Parameters.Add("EKRPFRMWSTF", OracleType.NVarChar).Value = dwData["EKRPFRMWSTF"].ToString(); 
          or1.Parameters.Add("EKRPPRME", OracleType.NVarChar).Value = dwData["EKRPPRME"].ToString(); 
          or1.Parameters.Add("EKRPPREH", OracleType.NVarChar).Value = dwData["EKRPPREH"].ToString(); 
          or1.Parameters.Add("EKRPPREHGRP", OracleType.NVarChar).Value = dwData["EKRPPREHGRP"].ToString(); 
          or1.Parameters.Add("EKRPPREHFKT", OracleType.NVarChar).Value = dwData["EKRPPREHFKT"].ToString(); 
          or1.Parameters.Add("EKRPZUAB1", OracleType.NVarChar).Value = dwData["EKRPZUAB1"].ToString(); 
          or1.Parameters.Add("EKRPZUABPR1", OracleType.NVarChar).Value = dwData["EKRPZUABPR1"].ToString(); 
          or1.Parameters.Add("EKRPZUABWE1", OracleType.NVarChar).Value = dwData["EKRPZUABWE1"].ToString(); 
          or1.Parameters.Add("EKRPZUABME1", OracleType.NVarChar).Value = dwData["EKRPZUABME1"].ToString(); 
          or1.Parameters.Add("EKRPZUABEB1", OracleType.NVarChar).Value = dwData["EKRPZUABEB1"].ToString(); 
          or1.Parameters.Add("EKRPZUABLV1", OracleType.NVarChar).Value = dwData["EKRPZUABLV1"].ToString(); 
          or1.Parameters.Add("EKRPZUABBETR1", OracleType.NVarChar).Value = dwData["EKRPZUABBETR1"].ToString(); 
          or1.Parameters.Add("EKRPZUAB2", OracleType.NVarChar).Value = dwData["EKRPZUAB2"].ToString(); 
          or1.Parameters.Add("EKRPZUABPR2", OracleType.NVarChar).Value = dwData["EKRPZUABPR2"].ToString(); 
          or1.Parameters.Add("EKRPZUABWE2", OracleType.NVarChar).Value = dwData["EKRPZUABWE2"].ToString(); 
          or1.Parameters.Add("EKRPZUABME2", OracleType.NVarChar).Value = dwData["EKRPZUABME2"].ToString(); 
          or1.Parameters.Add("EKRPZUABEB2", OracleType.NVarChar).Value = dwData["EKRPZUABEB2"].ToString(); 
          or1.Parameters.Add("EKRPZUABLV2", OracleType.NVarChar).Value = dwData["EKRPZUABLV2"].ToString(); 
          or1.Parameters.Add("EKRPZUABBETR2", OracleType.NVarChar).Value = dwData["EKRPZUABBETR2"].ToString(); 
          or1.Parameters.Add("EKRPZUAB3", OracleType.NVarChar).Value = dwData["EKRPZUAB3"].ToString(); 
          or1.Parameters.Add("EKRPZUABPR3", OracleType.NVarChar).Value = dwData["EKRPZUABPR3"].ToString(); 
          or1.Parameters.Add("EKRPZUABWE3", OracleType.NVarChar).Value = dwData["EKRPZUABWE3"].ToString(); 
          or1.Parameters.Add("EKRPZUABME3", OracleType.NVarChar).Value = dwData["EKRPZUABME3"].ToString(); 
          or1.Parameters.Add("EKRPZUABEB3", OracleType.NVarChar).Value = dwData["EKRPZUABEB3"].ToString(); 
          or1.Parameters.Add("EKRPZUABLV3", OracleType.NVarChar).Value = dwData["EKRPZUABLV3"].ToString(); 
          or1.Parameters.Add("EKRPZUABBETR3", OracleType.NVarChar).Value = dwData["EKRPZUABBETR3"].ToString(); 
          or1.Parameters.Add("EKRPZUAB4", OracleType.NVarChar).Value = dwData["EKRPZUAB4"].ToString(); 
          or1.Parameters.Add("EKRPZUABPR4", OracleType.NVarChar).Value = dwData["EKRPZUABPR4"].ToString(); 
          or1.Parameters.Add("EKRPZUABWE4", OracleType.NVarChar).Value = dwData["EKRPZUABWE4"].ToString(); 
          or1.Parameters.Add("EKRPZUABME4", OracleType.NVarChar).Value = dwData["EKRPZUABME4"].ToString(); 
          or1.Parameters.Add("EKRPZUABEB4", OracleType.NVarChar).Value = dwData["EKRPZUABEB4"].ToString(); 
          or1.Parameters.Add("EKRPZUABLV4", OracleType.NVarChar).Value = dwData["EKRPZUABLV4"].ToString(); 
          or1.Parameters.Add("EKRPZUABBETR4", OracleType.NVarChar).Value = dwData["EKRPZUABBETR4"].ToString(); 
          or1.Parameters.Add("EKRPZUAB5", OracleType.NVarChar).Value = dwData["EKRPZUAB5"].ToString(); 
          or1.Parameters.Add("EKRPZUABPR5", OracleType.NVarChar).Value = dwData["EKRPZUABPR5"].ToString(); 
          or1.Parameters.Add("EKRPZUABWE5", OracleType.NVarChar).Value = dwData["EKRPZUABWE5"].ToString(); 
          or1.Parameters.Add("EKRPZUABME5", OracleType.NVarChar).Value = dwData["EKRPZUABME5"].ToString(); 
          or1.Parameters.Add("EKRPZUABEB5", OracleType.NVarChar).Value = dwData["EKRPZUABEB5"].ToString(); 
          or1.Parameters.Add("EKRPZUABLV5", OracleType.NVarChar).Value = dwData["EKRPZUABLV5"].ToString(); 
          or1.Parameters.Add("EKRPZUABBETR5", OracleType.NVarChar).Value = dwData["EKRPZUABBETR5"].ToString(); 
          or1.Parameters.Add("EKRPRABATTKZ", OracleType.NVarChar).Value = dwData["EKRPRABATTKZ"].ToString(); 
          or1.Parameters.Add("EKRPRABATT", OracleType.NVarChar).Value = dwData["EKRPRABATT"].ToString(); 
          or1.Parameters.Add("EKRPRABATTWE", OracleType.NVarChar).Value = dwData["EKRPRABATTWE"].ToString(); 
          or1.Parameters.Add("EKRPRABART1", OracleType.NVarChar).Value = dwData["EKRPRABART1"].ToString(); 
          or1.Parameters.Add("EKRPRABPROZ1", OracleType.NVarChar).Value = dwData["EKRPRABPROZ1"].ToString(); 
          or1.Parameters.Add("EKRPRABWERT1", OracleType.NVarChar).Value = dwData["EKRPRABWERT1"].ToString(); 
          or1.Parameters.Add("EKRPRABEB1", OracleType.NVarChar).Value = dwData["EKRPRABEB1"].ToString(); 
          or1.Parameters.Add("EKRPRABLV1", OracleType.NVarChar).Value = dwData["EKRPRABLV1"].ToString(); 
          or1.Parameters.Add("EKRPRABART2", OracleType.NVarChar).Value = dwData["EKRPRABART2"].ToString(); 
          or1.Parameters.Add("EKRPRABPROZ2", OracleType.NVarChar).Value = dwData["EKRPRABPROZ2"].ToString(); 
          or1.Parameters.Add("EKRPRABWERT2", OracleType.NVarChar).Value = dwData["EKRPRABWERT2"].ToString(); 
          or1.Parameters.Add("EKRPRABEB2", OracleType.NVarChar).Value = dwData["EKRPRABEB2"].ToString(); 
          or1.Parameters.Add("EKRPRABLV2", OracleType.NVarChar).Value = dwData["EKRPRABLV2"].ToString(); 
          or1.Parameters.Add("EKRPRABART3", OracleType.NVarChar).Value = dwData["EKRPRABART3"].ToString(); 
          or1.Parameters.Add("EKRPRABPROZ3", OracleType.NVarChar).Value = dwData["EKRPRABPROZ3"].ToString(); 
          or1.Parameters.Add("EKRPRABWERT3", OracleType.NVarChar).Value = dwData["EKRPRABWERT3"].ToString(); 
          or1.Parameters.Add("EKRPRABEB3", OracleType.NVarChar).Value = dwData["EKRPRABEB3"].ToString(); 
          or1.Parameters.Add("EKRPRABLV3", OracleType.NVarChar).Value = dwData["EKRPRABLV3"].ToString(); 
          or1.Parameters.Add("EKRPRABART4", OracleType.NVarChar).Value = dwData["EKRPRABART4"].ToString(); 
          or1.Parameters.Add("EKRPRABPROZ4", OracleType.NVarChar).Value = dwData["EKRPRABPROZ4"].ToString(); 
          or1.Parameters.Add("EKRPRABWERT4", OracleType.NVarChar).Value = dwData["EKRPRABWERT4"].ToString(); 
          or1.Parameters.Add("EKRPRABEB4", OracleType.NVarChar).Value = dwData["EKRPRABEB4"].ToString(); 
          or1.Parameters.Add("EKRPRABLV4", OracleType.NVarChar).Value = dwData["EKRPRABLV4"].ToString(); 
          or1.Parameters.Add("EKRPRABART5", OracleType.NVarChar).Value = dwData["EKRPRABART5"].ToString(); 
          or1.Parameters.Add("EKRPRABPROZ5", OracleType.NVarChar).Value = dwData["EKRPRABPROZ5"].ToString(); 
          or1.Parameters.Add("EKRPRABWERT5", OracleType.NVarChar).Value = dwData["EKRPRABWERT5"].ToString(); 
          or1.Parameters.Add("EKRPRABEB5", OracleType.NVarChar).Value = dwData["EKRPRABEB5"].ToString(); 
          or1.Parameters.Add("EKRPRABLV5", OracleType.NVarChar).Value = dwData["EKRPRABLV5"].ToString(); 
          or1.Parameters.Add("EKRPFIXBONP", OracleType.NVarChar).Value = dwData["EKRPFIXBONP"].ToString(); 
          or1.Parameters.Add("EKRPFIXBONA", OracleType.NVarChar).Value = dwData["EKRPFIXBONA"].ToString(); 
          or1.Parameters.Add("EKRPKALBONP", OracleType.NVarChar).Value = dwData["EKRPKALBONP"].ToString(); 
          or1.Parameters.Add("EKRPKALBONA", OracleType.NVarChar).Value = dwData["EKRPKALBONA"].ToString(); 
          or1.Parameters.Add("EKRPKONAB", OracleType.NVarChar).Value = dwData["EKRPKONAB"].ToString(); 
          or1.Parameters.Add("EKRPKODIFFME", OracleType.NVarChar).Value = dwData["EKRPKODIFFME"].ToString(); 
          or1.Parameters.Add("EKRPKODIFFWE", OracleType.NVarChar).Value = dwData["EKRPKODIFFWE"].ToString(); 
          or1.Parameters.Add("EKRPKTOKL4", OracleType.NVarChar).Value = dwData["EKRPKTOKL4"].ToString(); 
          or1.Parameters.Add("EKRPKSTKRS", OracleType.NVarChar).Value = dwData["EKRPKSTKRS"].ToString(); 
          or1.Parameters.Add("EKRPKST", OracleType.NVarChar).Value = dwData["EKRPKST"].ToString(); 
          or1.Parameters.Add("EKRPBUDGET", OracleType.NVarChar).Value = dwData["EKRPBUDGET"].ToString(); 
          or1.Parameters.Add("EKRPINVAUF", OracleType.NVarChar).Value = dwData["EKRPINVAUF"].ToString(); 
          or1.Parameters.Add("EKRPWAEHRSL", OracleType.NVarChar).Value = dwData["EKRPWAEHRSL"].ToString(); 
          or1.Parameters.Add("EKRPKURS", OracleType.NVarChar).Value = dwData["EKRPKURS"].ToString(); 
          or1.Parameters.Add("EKRPBETRAG", OracleType.NVarChar).Value = dwData["EKRPBETRAG"].ToString(); 
          or1.Parameters.Add("EKRPHWAEHRSL", OracleType.NVarChar).Value = dwData["EKRPHWAEHRSL"].ToString(); 
          or1.Parameters.Add("EKRPHEUROKURS", OracleType.NVarChar).Value = dwData["EKRPHEUROKURS"].ToString(); 
          or1.Parameters.Add("EKRPHEUROKUVK", OracleType.NVarChar).Value = dwData["EKRPHEUROKUVK"].ToString(); 
          or1.Parameters.Add("EKRPFEUROKURS", OracleType.NVarChar).Value = dwData["EKRPFEUROKURS"].ToString(); 
          or1.Parameters.Add("EKRPFEUROKUVK", OracleType.NVarChar).Value = dwData["EKRPFEUROKUVK"].ToString(); 
          or1.Parameters.Add("EKRPTERMNR", OracleType.NVarChar).Value = dwData["EKRPTERMNR"].ToString(); 
          or1.Parameters.Add("EKRPFAELLIG", OracleType.NVarChar).Value = dwData["EKRPFAELLIG"].ToString(); 
          or1.Parameters.Add("EKRPSICHER", OracleType.NVarChar).Value = dwData["EKRPSICHER"].ToString(); 
          or1.Parameters.Add("EKRPSICHP", OracleType.NVarChar).Value = dwData["EKRPSICHP"].ToString(); 
          or1.Parameters.Add("EKRPAKKRED", OracleType.NVarChar).Value = dwData["EKRPAKKRED"].ToString(); 
          or1.Parameters.Add("EKRPPRFBENID", OracleType.NVarChar).Value = dwData["EKRPPRFBENID"].ToString(); 
          or1.Parameters.Add("EKRPMAILDAT", OracleType.NVarChar).Value = dwData["EKRPMAILDAT"].ToString(); 
          or1.Parameters.Add("EKRPUEBKZ", OracleType.NVarChar).Value = dwData["EKRPUEBKZ"].ToString(); 
          or1.Parameters.Add("EKRPURLAND", OracleType.NVarChar).Value = dwData["EKRPURLAND"].ToString(); 
          or1.Parameters.Add("EKRPWR", OracleType.NVarChar).Value = dwData["EKRPWR"].ToString(); 
          or1.Parameters.Add("EKRPPRFBEG", OracleType.NVarChar).Value = dwData["EKRPPRFBEG"].ToString(); 
          or1.Parameters.Add("EKRPPRFSCHL", OracleType.NVarChar).Value = dwData["EKRPPRFSCHL"].ToString(); 
          or1.Parameters.Add("EKRPZOLLTNR", OracleType.NVarChar).Value = dwData["EKRPZOLLTNR"].ToString(); 
          or1.Parameters.Add("EKRPLEKLNR", OracleType.NVarChar).Value = dwData["EKRPLEKLNR"].ToString(); 
          or1.Parameters.Add("EKRPVBCOSTS", OracleType.NVarChar).Value = dwData["EKRPVBCOSTS"].ToString(); 
          or1.Parameters.Add("EKRPFRAGR", OracleType.NVarChar).Value = dwData["EKRPFRAGR"].ToString(); 
          or1.Parameters.Add("EKRPVERSGR", OracleType.NVarChar).Value = dwData["EKRPVERSGR"].ToString(); 
          or1.Parameters.Add("EKRPSTZOLLP", OracleType.NVarChar).Value = dwData["EKRPSTZOLLP"].ToString(); 
          or1.Parameters.Add("EKRPSTZOLLAB", OracleType.NVarChar).Value = dwData["EKRPSTZOLLAB"].ToString(); 
          or1.Parameters.Add("EKRPIMCOSTS", OracleType.NVarChar).Value = dwData["EKRPIMCOSTS"].ToString(); 
          or1.Parameters.Add("EKRPCOBORDER", OracleType.NVarChar).Value = dwData["EKRPCOBORDER"].ToString(); 
          or1.Parameters.Add("EKRPAVVME", OracleType.NVarChar).Value = dwData["EKRPAVVME"].ToString(); 
          or1.Parameters.Add("EKRPZOLLANM", OracleType.NVarChar).Value = dwData["EKRPZOLLANM"].ToString(); 
          or1.Parameters.Add("EKRPEUR1", OracleType.NVarChar).Value = dwData["EKRPEUR1"].ToString(); 
          or1.Parameters.Add("EKRPZUSTAND", OracleType.NVarChar).Value = dwData["EKRPZUSTAND"].ToString(); 
          or1.Parameters.Add("EKRPINTRA", OracleType.NVarChar).Value = dwData["EKRPINTRA"].ToString(); 
          or1.Parameters.Add("EKRPGRUND", OracleType.NVarChar).Value = dwData["EKRPGRUND"].ToString(); 
          or1.Parameters.Add("EKRPRRENR", OracleType.NVarChar).Value = dwData["EKRPRRENR"].ToString(); 
          or1.Parameters.Add("EKRPRREPOS", OracleType.NVarChar).Value = dwData["EKRPRREPOS"].ToString(); 
          or1.Parameters.Add("EKRPWERTDAT", OracleType.NVarChar).Value = dwData["EKRPWERTDAT"].ToString(); 
          or1.Parameters.Add("EKRPLANDCOST", OracleType.NVarChar).Value = dwData["EKRPLANDCOST"].ToString(); 
          or1.Parameters.Add("EKRPFILLER5", OracleType.NVarChar).Value = dwData["EKRPFILLER5"].ToString(); 
                    #endregion
                    break; 
                default:
                    break;
            }


            Connect2Proxy(or1);
        }
    }
}
